Cars Profiling

Dataset statistics

Number of variables	13
Number of observations	6999
Missing cells	1006
Missing cells (%)	1.1%
Duplicate rows	493
Duplicate rows (%)	7.0%
Total size in memory	287.8 KiB
Average record size in memory	42.1 B

Variable types

Text	1
Numeric	8
Categorical	4

Alerts

Dataset has 493 (7.0%) duplicate rows	Duplicates
`engine` is highly overall correlated with `max_power` and 3 other fields	High correlation
`km_driven` is highly overall correlated with `year`	High correlation
`max_power` is highly overall correlated with `engine` and 3 other fields	High correlation
`seats` is highly overall correlated with `engine`	High correlation
`selling_price` is highly overall correlated with `engine` and 4 other fields	High correlation
`torque` is highly overall correlated with `engine` and 2 other fields	High correlation
`transmission` is highly overall correlated with `max_power` and 1 other fields	High correlation
`year` is highly overall correlated with `km_driven` and 1 other fields	High correlation
`seller_type` is highly imbalanced (51.8%)	Imbalance
`mileage` has 202 (2.9%) missing values	Missing
`engine` has 202 (2.9%) missing values	Missing
`max_power` has 197 (2.8%) missing values	Missing
`torque` has 203 (2.9%) missing values	Missing
`seats` has 202 (2.9%) missing values	Missing

Reproduction

Analysis started	2026-01-01 16:55:16.466942
Analysis finished	2026-01-01 16:55:19.493761
Duration	3.03 seconds
Software version	ydata-profiling vv4.18.0
Download configuration	config.json

name
Text

Distinct	1924
Distinct (%)	27.5%
Missing	0
Missing (%)	0.0%
Memory size	54.8 KiB

Length

Max length	54
Median length	42
Mean length	25.227747
Min length	11

Characters and Unicode

Total characters	176569
Distinct characters	68
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	804 ?
Unique (%)	11.5%

Sample

1st row	Maruti Swift Dzire VDI
2nd row	Skoda Rapid 1.5 TDI Ambition
3rd row	Hyundai i20 Sportz Diesel
4th row	Maruti Swift VXI BSIII
5th row	Hyundai Xcent 1.2 VTVT E Plus

Value	Count	Frequency (%)
maruti	2126	6.4%
hyundai	1197	3.6%
swift	689	2.1%
mahindra	666	2.0%
bsiv	622	1.9%
tata	611	1.8%
diesel	583	1.8%
1.2	505	1.5%
vxi	485	1.5%
plus	459	1.4%
Other values (828)	25224	76.1%

Most occurring characters

Value	Count	Frequency (%)
	26169	14.8%
a	12741	7.2%
i	11534	6.5%
t	8812	5.0%
r	7759	4.4%
o	7165	4.1%
n	6573	3.7%
e	6564	3.7%
u	5091	2.9%
S	4755	2.7%
Other values (58)	79406	45.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	176569	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	26169	14.8%
a	12741	7.2%
i	11534	6.5%
t	8812	5.0%
r	7759	4.4%
o	7165	4.1%
n	6573	3.7%
e	6564	3.7%
u	5091	2.9%
S	4755	2.7%
Other values (58)	79406	45.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	176569	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	26169	14.8%
a	12741	7.2%
i	11534	6.5%
t	8812	5.0%
r	7759	4.4%
o	7165	4.1%
n	6573	3.7%
e	6564	3.7%
u	5091	2.9%
S	4755	2.7%
Other values (58)	79406	45.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	176569	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	26169	14.8%
a	12741	7.2%
i	11534	6.5%
t	8812	5.0%
r	7759	4.4%
o	7165	4.1%
n	6573	3.7%
e	6564	3.7%
u	5091	2.9%
S	4755	2.7%
Other values (58)	79406	45.0%

year
Real number (ℝ)

High correlation

Distinct	29
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2013.8184

Minimum	1983
Maximum	2020
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	13.8 KiB

Quantile statistics

Minimum	1983
5-th percentile	2006
Q1	2011
median	2015
Q3	2017
95-th percentile	2019
Maximum	2020
Range	37
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	4.0530948
Coefficient of variation (CV)	0.0020126417
Kurtosis	1.7672148
Mean	2013.8184
Median Absolute Deviation (MAD)	3
Skewness	-1.0773023
Sum	14094715
Variance	16.427578
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=29)

Value	Count	Frequency (%)
2017	870	12.4%
2016	736	10.5%
2018	704	10.1%
2015	662	9.5%
2013	581	8.3%
2012	563	8.0%
2014	532	7.6%
2019	511	7.3%
2011	499	7.1%
2010	336	4.8%
Other values (19)	1005	14.4%

Value	Count	Frequency (%)
1983	1	< 0.1%
1991	1	< 0.1%
1994	3	< 0.1%
1995	1	< 0.1%
1996	3	< 0.1%
1997	10	0.1%
1998	9	0.1%
1999	13	0.2%
2000	21	0.3%
2001	8	0.1%

Value	Count	Frequency (%)
2020	69	1.0%
2019	511	7.3%
2018	704	10.1%
2017	870	12.4%
2016	736	10.5%
2015	662	9.5%
2014	532	7.6%
2013	581	8.3%
2012	563	8.0%
2011	499	7.1%

selling_price
Real number (ℝ)

High correlation

Distinct	637
Distinct (%)	9.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	639515.2

Minimum	29999
Maximum	10000000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	27.5 KiB

Quantile statistics

Minimum	29999
5-th percentile	110000
Q1	254999
median	450000
Q3	675000
95-th percentile	1925000
Maximum	10000000
Range	9970001
Interquartile range (IQR)	420001

Descriptive statistics

Standard deviation	808941.91
Coefficient of variation (CV)	1.2649299
Kurtosis	21.308644
Mean	639515.2
Median Absolute Deviation (MAD)	200000
Skewness	4.2107557
Sum	4.4759669 × 10⁹
Variance	6.5438702 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
300000	196	2.8%
600000	181	2.6%
450000	178	2.5%
350000	178	2.5%
550000	175	2.5%
650000	161	2.3%
400000	153	2.2%
250000	153	2.2%
500000	152	2.2%
200000	138	2.0%
Other values (627)	5334	76.2%

Value	Count	Frequency (%)
29999	1	< 0.1%
30000	2	< 0.1%
31504	1	< 0.1%
35000	3	< 0.1%
39000	1	< 0.1%
40000	12	0.2%
42000	2	< 0.1%
45000	16	0.2%
45957	2	< 0.1%
50000	15	0.2%

Value	Count	Frequency (%)
10000000	1	< 0.1%
7200000	1	< 0.1%
6523000	1	< 0.1%
6223000	1	< 0.1%
6000000	4	0.1%
5923000	1	< 0.1%
5850000	1	< 0.1%
5830000	2	< 0.1%
5800000	2	< 0.1%
5500000	27	0.4%

km_driven
Real number (ℝ)

High correlation

Distinct	827
Distinct (%)	11.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	69584.616

Minimum	1
Maximum	2360457
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	27.5 KiB

Quantile statistics

Minimum	1
5-th percentile	9000
Q1	35000
median	60000
Q3	97000
95-th percentile	150000
Maximum	2360457
Range	2360456
Interquartile range (IQR)	62000

Descriptive statistics

Standard deviation	57724.002
Coefficient of variation (CV)	0.82955121
Kurtosis	410.79799
Mean	69584.616
Median Absolute Deviation (MAD)	30000
Skewness	12.069152
Sum	4.8702272 × 10⁸
Variance	3.3320604 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
120000	464	6.6%
70000	389	5.6%
80000	387	5.5%
60000	367	5.2%
50000	343	4.9%
100000	306	4.4%
90000	291	4.2%
110000	264	3.8%
40000	260	3.7%
30000	215	3.1%
Other values (817)	3713	53.1%

Value	Count	Frequency (%)
1	1	< 0.1%
1000	6	0.1%
1300	1	< 0.1%
1303	4	0.1%
1500	3	< 0.1%
1600	1	< 0.1%
1620	1	< 0.1%
2000	28	0.4%
2118	1	< 0.1%
2136	1	< 0.1%

Value	Count	Frequency (%)
2360457	1	< 0.1%
1500000	1	< 0.1%
577414	1	< 0.1%
500000	2	< 0.1%
475000	1	< 0.1%
440000	1	< 0.1%
426000	1	< 0.1%
380000	1	< 0.1%
376412	1	< 0.1%
370000	1	< 0.1%

fuel
Categorical

Distinct	4
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.2 KiB

Diesel	3793
Petrol	3120
CNG	52
LPG	34

Length

Max length	6
Median length	6
Mean length	5.9631376
Min length	3

Characters and Unicode

Total characters	41736
Distinct characters	13
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Diesel
2nd row	Diesel
3rd row	Diesel
4th row	Petrol
5th row	Petrol

Common Values

Value	Count	Frequency (%)
Diesel	3793	54.2%
Petrol	3120	44.6%
CNG	52	0.7%
LPG	34	0.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
diesel	3793	54.2%
petrol	3120	44.6%
cng	52	0.7%
lpg	34	0.5%

Most occurring characters

Value	Count	Frequency (%)
e	10706	25.7%
l	6913	16.6%
D	3793	9.1%
i	3793	9.1%
s	3793	9.1%
P	3154	7.6%
t	3120	7.5%
r	3120	7.5%
o	3120	7.5%
G	86	0.2%
Other values (3)	138	0.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	41736	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	10706	25.7%
l	6913	16.6%
D	3793	9.1%
i	3793	9.1%
s	3793	9.1%
P	3154	7.6%
t	3120	7.5%
r	3120	7.5%
o	3120	7.5%
G	86	0.2%
Other values (3)	138	0.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	41736	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	10706	25.7%
l	6913	16.6%
D	3793	9.1%
i	3793	9.1%
s	3793	9.1%
P	3154	7.6%
t	3120	7.5%
r	3120	7.5%
o	3120	7.5%
G	86	0.2%
Other values (3)	138	0.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	41736	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	10706	25.7%
l	6913	16.6%
D	3793	9.1%
i	3793	9.1%
s	3793	9.1%
P	3154	7.6%
t	3120	7.5%
r	3120	7.5%
o	3120	7.5%
G	86	0.2%
Other values (3)	138	0.3%

seller_type
Categorical

Imbalance

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.1 KiB

Individual	5826
Dealer	967
Trustmark Dealer	206

Length

Max length	16
Median length	10
Mean length	9.6239463
Min length	6

Characters and Unicode

Total characters	67358
Distinct characters	17
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Individual
2nd row	Individual
3rd row	Individual
4th row	Individual
5th row	Individual

Common Values

Value	Count	Frequency (%)
Individual	5826	83.2%
Dealer	967	13.8%
Trustmark Dealer	206	2.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
individual	5826	80.9%
dealer	1173	16.3%
trustmark	206	2.9%

Most occurring characters

Value	Count	Frequency (%)
d	11652	17.3%
i	11652	17.3%
a	7205	10.7%
l	6999	10.4%
u	6032	9.0%
I	5826	8.6%
v	5826	8.6%
n	5826	8.6%
e	2346	3.5%
r	1585	2.4%
Other values (7)	2409	3.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	67358	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
d	11652	17.3%
i	11652	17.3%
a	7205	10.7%
l	6999	10.4%
u	6032	9.0%
I	5826	8.6%
v	5826	8.6%
n	5826	8.6%
e	2346	3.5%
r	1585	2.4%
Other values (7)	2409	3.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	67358	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
d	11652	17.3%
i	11652	17.3%
a	7205	10.7%
l	6999	10.4%
u	6032	9.0%
I	5826	8.6%
v	5826	8.6%
n	5826	8.6%
e	2346	3.5%
r	1585	2.4%
Other values (7)	2409	3.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	67358	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
d	11652	17.3%
i	11652	17.3%
a	7205	10.7%
l	6999	10.4%
u	6032	9.0%
I	5826	8.6%
v	5826	8.6%
n	5826	8.6%
e	2346	3.5%
r	1585	2.4%
Other values (7)	2409	3.6%

transmission
Categorical

High correlation

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.1 KiB

Manual	6095
Automatic	904

Length

Max length	9
Median length	6
Mean length	6.3874839
Min length	6

Characters and Unicode

Total characters	44706
Distinct characters	11
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Manual
2nd row	Manual
3rd row	Manual
4th row	Manual
5th row	Manual

Common Values

Value	Count	Frequency (%)
Manual	6095	87.1%
Automatic	904	12.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
manual	6095	87.1%
automatic	904	12.9%

Most occurring characters

Value	Count	Frequency (%)
a	13094	29.3%
u	6999	15.7%
M	6095	13.6%
n	6095	13.6%
l	6095	13.6%
t	1808	4.0%
A	904	2.0%
o	904	2.0%
m	904	2.0%
i	904	2.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	44706	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	13094	29.3%
u	6999	15.7%
M	6095	13.6%
n	6095	13.6%
l	6095	13.6%
t	1808	4.0%
A	904	2.0%
o	904	2.0%
m	904	2.0%
i	904	2.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	44706	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	13094	29.3%
u	6999	15.7%
M	6095	13.6%
n	6095	13.6%
l	6095	13.6%
t	1808	4.0%
A	904	2.0%
o	904	2.0%
m	904	2.0%
i	904	2.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	44706	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	13094	29.3%
u	6999	15.7%
M	6095	13.6%
n	6095	13.6%
l	6095	13.6%
t	1808	4.0%
A	904	2.0%
o	904	2.0%
m	904	2.0%
i	904	2.0%

owner
Categorical

Distinct	5
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.2 KiB

First Owner	4587
Second Owner	1791
Third Owner	473
Fourth & Above Owner	144
Test Drive Car	4

Length

Max length	20
Median length	11
Mean length	11.442778
Min length	11

Characters and Unicode

Total characters	80088
Distinct characters	24
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	First Owner
2nd row	Second Owner
3rd row	First Owner
4th row	First Owner
5th row	First Owner

Common Values

Value	Count	Frequency (%)
First Owner	4587	65.5%
Second Owner	1791	25.6%
Third Owner	473	6.8%
Fourth & Above Owner	144	2.1%
Test Drive Car	4	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
owner	6995	49.0%
first	4587	32.1%
second	1791	12.5%
third	473	3.3%
fourth	144	1.0%
	144	1.0%
above	144	1.0%
test	4	< 0.1%
drive	4	< 0.1%
car	4	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
r	12207	15.2%
e	8938	11.2%
n	8786	11.0%
	7291	9.1%
O	6995	8.7%
w	6995	8.7%
i	5064	6.3%
t	4735	5.9%
F	4731	5.9%
s	4591	5.7%
Other values (14)	9755	12.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	80088	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
r	12207	15.2%
e	8938	11.2%
n	8786	11.0%
	7291	9.1%
O	6995	8.7%
w	6995	8.7%
i	5064	6.3%
t	4735	5.9%
F	4731	5.9%
s	4591	5.7%
Other values (14)	9755	12.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	80088	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
r	12207	15.2%
e	8938	11.2%
n	8786	11.0%
	7291	9.1%
O	6995	8.7%
w	6995	8.7%
i	5064	6.3%
t	4735	5.9%
F	4731	5.9%
s	4591	5.7%
Other values (14)	9755	12.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	80088	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
r	12207	15.2%
e	8938	11.2%
n	8786	11.0%
	7291	9.1%
O	6995	8.7%
w	6995	8.7%
i	5064	6.3%
t	4735	5.9%
F	4731	5.9%
s	4591	5.7%
Other values (14)	9755	12.2%

mileage
Real number (ℝ)

Missing

Distinct	375
Distinct (%)	5.5%
Missing	202
Missing (%)	2.9%
Infinite	0
Infinite (%)	0.0%
Mean	19.426604

Minimum	0
Maximum	42
Zeros	16
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	27.5 KiB

Quantile statistics

Minimum	0
5-th percentile	12.99
Q1	16.799999
median	19.299999
Q3	22.32
95-th percentile	25.83
Maximum	42
Range	42
Interquartile range (IQR)	5.5200005

Descriptive statistics

Standard deviation	4.045692
Coefficient of variation (CV)	0.20825523
Kurtosis	0.67758536
Mean	19.426604
Median Absolute Deviation (MAD)	2.7000008
Skewness	-0.15136978
Sum	132042.63
Variance	16.367624
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
18.89999962	197	2.8%
19.70000076	150	2.1%
18.60000038	139	2.0%
21.10000038	131	1.9%
17	116	1.7%
15.96000004	105	1.5%
17.79999924	101	1.4%
22	99	1.4%
12.98999977	95	1.4%
16.10000038	90	1.3%
Other values (365)	5574	79.6%
(Missing)	202	2.9%

Value	Count	Frequency (%)
0	16	0.2%
9	4	0.1%
9.5	5	0.1%
10	2	< 0.1%
10.10000038	2	< 0.1%
10.5	14	0.2%
10.71000004	1	< 0.1%
10.75	2	< 0.1%
10.80000019	1	< 0.1%
10.89999962	4	0.1%

Value	Count	Frequency (%)
42	1	< 0.1%
33.43999863	3	< 0.1%
33	1	< 0.1%
32.52000046	1	< 0.1%
30.45999908	2	< 0.1%
28.39999962	80	1.1%
28.09000015	36	0.5%
27.62000084	5	0.1%
27.39999962	6	0.1%
27.38999939	49	0.7%

engine
Real number (ℝ)

High correlation Missing

Distinct	120
Distinct (%)	1.8%
Missing	202
Missing (%)	2.9%
Infinite	0
Infinite (%)	0.0%
Mean	1458.3272

Minimum	624
Maximum	3604
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	27.5 KiB

Quantile statistics

Minimum	624
5-th percentile	796
Q1	1197
median	1248
Q3	1582
95-th percentile	2499
Maximum	3604
Range	2980
Interquartile range (IQR)	385

Descriptive statistics

Standard deviation	501.1839
Coefficient of variation (CV)	0.3436704
Kurtosis	0.73242486
Mean	1458.3272
Median Absolute Deviation (MAD)	248
Skewness	1.1392183
Sum	9912250
Variance	251185.3
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1248	885	12.6%
1197	715	10.2%
998	393	5.6%
796	375	5.4%
2179	330	4.7%
1498	318	4.5%
1396	264	3.8%
1199	233	3.3%
2494	188	2.7%
2523	171	2.4%
Other values (110)	2925	41.8%
(Missing)	202	2.9%

Value	Count	Frequency (%)
624	16	0.2%
793	5	0.1%
796	375	5.4%
799	66	0.9%
814	99	1.4%
909	2	< 0.1%
936	31	0.4%
993	24	0.3%
995	41	0.6%
998	393	5.6%

Value	Count	Frequency (%)
3604	5	0.1%
3498	1	< 0.1%
3198	3	< 0.1%
2999	3	< 0.1%
2997	2	< 0.1%
2993	14	0.2%
2987	9	0.1%
2982	28	0.4%
2967	9	0.1%
2956	15	0.2%

max_power
Real number (ℝ)

High correlation Missing

Distinct	313
Distinct (%)	4.6%
Missing	197
Missing (%)	2.8%
Infinite	0
Infinite (%)	0.0%
Mean	91.500023

Minimum	0
Maximum	400
Zeros	6
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	27.5 KiB

Quantile statistics

Minimum	0
5-th percentile	47.299999
Q1	68.050003
median	82
Q3	102
95-th percentile	171.5
Maximum	400
Range	400
Interquartile range (IQR)	33.949997

Descriptive statistics

Standard deviation	35.821621
Coefficient of variation (CV)	0.39149303
Kurtosis	3.891552
Mean	91.500023
Median Absolute Deviation (MAD)	14.959999
Skewness	1.6386213
Sum	622383.16
Variance	1283.1886
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
74	330	4.7%
81.80000305	193	2.8%
88.5	189	2.7%
67	149	2.1%
46.29999924	139	2.0%
62.09999847	130	1.9%
67.09999847	127	1.8%
67.04000092	126	1.8%
88.69999695	125	1.8%
70	117	1.7%
Other values (303)	5177	74.0%
(Missing)	197	2.8%

Value	Count	Frequency (%)
0	6	0.1%
32.79999924	2	< 0.1%
34.20000076	19	0.3%
35	16	0.2%
35.5	2	< 0.1%
37	74	1.1%
37.47999954	8	0.1%
37.5	6	0.1%
38	1	< 0.1%
38.40000153	2	< 0.1%

Value	Count	Frequency (%)
400	1	< 0.1%
282	1	< 0.1%
280	5	0.1%
272	1	< 0.1%
270.8999939	3	< 0.1%
265	1	< 0.1%
261.3999939	6	0.1%
258	2	< 0.1%
254.8000031	3	< 0.1%
254.7899933	1	< 0.1%

torque
Real number (ℝ)

High correlation Missing

Distinct	243
Distinct (%)	3.6%
Missing	203
Missing (%)	2.9%
Infinite	0
Infinite (%)	0.0%
Mean	184.76681

Minimum	47.071918
Maximum	5001.3916
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	27.5 KiB

Quantile statistics

Minimum	47.071918
5-th percentile	69
Q1	111.8
median	170
Q3	209
95-th percentile	360
Maximum	5001.3916
Range	4954.3198
Interquartile range (IQR)	97.199997

Descriptive statistics

Standard deviation	155.15225
Coefficient of variation (CV)	0.83971927
Kurtosis	316.4653
Mean	184.76681
Median Absolute Deviation (MAD)	56.25
Skewness	12.998838
Sum	1255675.3
Variance	24072.221
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
200	596	8.5%
190	535	7.6%
90	353	5.0%
113	228	3.3%
114	211	3.0%
160	148	2.1%
400	145	2.1%
62	142	2.0%
320	130	1.9%
110	130	1.9%
Other values (233)	4178	59.7%
(Missing)	203	2.9%

Value	Count	Frequency (%)
47.07191849	1	< 0.1%
51	14	0.2%
55.89790344	1	< 0.1%
57	2	< 0.1%
58.83990097	1	< 0.1%
59	92	1.3%
59.82056427	14	0.2%
60	3	< 0.1%
62	142	2.0%
69	116	1.7%

Value	Count	Frequency (%)
5001.391602	2	< 0.1%
2451.662598	2	< 0.1%
2059.396484	7	0.1%
1863.26355	1	< 0.1%
1421.964233	9	0.1%
1274.864502	3	< 0.1%
1127.764771	6	0.1%
1078.731445	1	< 0.1%
789	3	< 0.1%
640	1	< 0.1%

seats
Real number (ℝ)

High correlation Missing

Distinct	9
Distinct (%)	0.1%
Missing	202
Missing (%)	2.9%
Infinite	0
Infinite (%)	0.0%
Mean	5.4190084

Minimum	2
Maximum	14
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	27.5 KiB

Quantile statistics

Minimum	2
5-th percentile	5
Q1	5
median	5
Q3	5
95-th percentile	7
Maximum	14
Range	12
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.96576655
Coefficient of variation (CV)	0.17821832
Kurtosis	4.0454431
Mean	5.4190084
Median Absolute Deviation (MAD)	0
Skewness	2.0111742
Sum	36833
Variance	0.93270504
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
5	5393	77.1%
7	944	13.5%
8	208	3.0%
4	104	1.5%
9	72	1.0%
6	54	0.8%
10	19	0.3%
2	2	< 0.1%
14	1	< 0.1%
(Missing)	202	2.9%

Value	Count	Frequency (%)
2	2	< 0.1%
4	104	1.5%
5	5393	77.1%
6	54	0.8%
7	944	13.5%
8	208	3.0%
9	72	1.0%
10	19	0.3%
14	1	< 0.1%

Value	Count	Frequency (%)
14	1	< 0.1%
10	19	0.3%
9	72	1.0%
8	208	3.0%
7	944	13.5%
6	54	0.8%
5	5393	77.1%
4	104	1.5%
2	2	< 0.1%

	engine	fuel	km_driven	max_power	mileage	owner	seats	seller_type	selling_price	torque	transmission	year
engine	1.000	0.450	0.238	0.736	-0.462	0.082	0.515	0.229	0.512	0.844	0.489	-0.006
fuel	0.450	1.000	0.035	0.168	0.309	0.031	0.213	0.108	0.110	0.027	0.050	0.122
km_driven	0.238	0.035	1.000	-0.036	-0.157	0.034	0.225	0.018	-0.358	0.180	0.027	-0.620
max_power	0.736	0.168	-0.036	1.000	-0.345	0.085	0.275	0.258	0.669	0.793	0.593	0.220
mileage	-0.462	0.309	-0.157	-0.345	1.000	0.086	-0.439	0.070	-0.031	-0.199	0.212	0.302
owner	0.082	0.031	0.034	0.085	0.086	1.000	0.034	0.169	0.364	0.032	0.169	0.269
seats	0.515	0.213	0.225	0.275	-0.439	0.034	1.000	0.064	0.261	0.402	0.075	-0.013
seller_type	0.229	0.108	0.018	0.258	0.070	0.169	0.064	1.000	0.282	0.000	0.373	0.185
selling_price	0.512	0.110	-0.358	0.669	-0.031	0.364	0.261	0.282	1.000	0.611	0.586	0.714
torque	0.844	0.027	0.180	0.793	-0.199	0.032	0.402	0.000	0.611	1.000	0.154	0.126
transmission	0.489	0.050	0.027	0.593	0.212	0.169	0.075	0.373	0.586	0.154	1.000	0.269
year	-0.006	0.122	-0.620	0.220	0.302	0.269	-0.013	0.185	0.714	0.126	0.269	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

	name	year	selling_price	km_driven	fuel	seller_type	transmission	owner	mileage	engine	max_power	torque	seats
0	Maruti Swift Dzire VDI	2014	450000	145500	Diesel	Individual	Manual	First Owner	23.400000	1248.0	74.000000	190.000000	5.0
1	Skoda Rapid 1.5 TDI Ambition	2014	370000	120000	Diesel	Individual	Manual	Second Owner	21.139999	1498.0	103.519997	250.000000	5.0
2	Hyundai i20 Sportz Diesel	2010	225000	127000	Diesel	Individual	Manual	First Owner	23.000000	1396.0	90.000000	219.668961	5.0
3	Maruti Swift VXI BSIII	2007	130000	120000	Petrol	Individual	Manual	First Owner	16.100000	1298.0	88.199997	112.776474	5.0
4	Hyundai Xcent 1.2 VTVT E Plus	2017	440000	45000	Petrol	Individual	Manual	First Owner	20.139999	1197.0	81.860001	113.750000	5.0
5	Maruti Wagon R LXI DUO BSIII	2007	96000	175000	LPG	Individual	Manual	First Owner	17.299999	1061.0	57.500000	76.491867	5.0
6	Maruti 800 DX BSII	2001	45000	5000	Petrol	Individual	Manual	Second Owner	16.100000	796.0	37.000000	59.000000	4.0
7	Toyota Etios VXD	2011	350000	90000	Diesel	Individual	Manual	First Owner	23.590000	1364.0	67.099998	170.000000	5.0
8	Ford Figo Diesel Celebration Edition	2013	200000	169000	Diesel	Individual	Manual	First Owner	20.000000	1399.0	68.099998	160.000000	5.0
9	Renault Duster 110PS Diesel RxL	2014	500000	68000	Diesel	Individual	Manual	Second Owner	19.010000	1461.0	108.449997	248.000000	5.0

	name	year	selling_price	km_driven	fuel	seller_type	transmission	owner	mileage	engine	max_power	torque	seats
6989	Maruti Swift Dzire VDI	2015	625000	50000	Diesel	Individual	Manual	First Owner	26.590000	1248.0	74.000000	190.000000	5.0
6990	Hyundai i20 Magna	2013	380000	25000	Petrol	Individual	Manual	First Owner	18.500000	1197.0	82.849998	113.699997	5.0
6991	Maruti Wagon R LXI Optional	2017	360000	80000	Petrol	Individual	Manual	First Owner	20.510000	998.0	67.040001	90.000000	5.0
6992	Hyundai Santro Xing GLS	2008	120000	191000	Petrol	Individual	Manual	First Owner	17.920000	1086.0	62.099998	96.099998	5.0
6993	Maruti Wagon R VXI BS IV with ABS	2013	260000	50000	Petrol	Individual	Manual	Second Owner	18.900000	998.0	67.099998	90.000000	5.0
6994	Hyundai i20 Magna	2013	320000	110000	Petrol	Individual	Manual	First Owner	18.500000	1197.0	82.849998	113.699997	5.0
6995	Hyundai Verna CRDi SX	2007	135000	119000	Diesel	Individual	Manual	Fourth & Above Owner	16.799999	1493.0	110.000000	235.359604	5.0
6996	Maruti Swift Dzire ZDi	2009	382000	120000	Diesel	Individual	Manual	First Owner	19.299999	1248.0	73.900002	190.000000	5.0
6997	Tata Indigo CR4	2013	290000	25000	Diesel	Individual	Manual	First Owner	23.570000	1396.0	70.000000	140.000000	5.0
6998	Tata Indigo CR4	2013	290000	25000	Diesel	Individual	Manual	First Owner	23.570000	1396.0	70.000000	140.000000	5.0

Most frequently occurring

	name	year	selling_price	km_driven	fuel	seller_type	transmission	owner	mileage	engine	max_power	torque	seats	# duplicates
64	Honda Amaze V CVT Petrol BSIV	2019	779000	7032	Petrol	Trustmark Dealer	Automatic	First Owner	19.000000	1199.0	88.760002	110.000000	5.0	30
192	Lexus ES 300h	2019	5150000	20000	Petrol	Dealer	Automatic	First Owner	22.370001	2487.0	214.559998	202.000000	5.0	30
183	Jaguar XF 2.0 Diesel Portfolio	2017	3200000	45000	Diesel	Dealer	Automatic	First Owner	19.330000	1999.0	177.000000	430.000000	5.0	28
467	Toyota Innova 2.5 VX (Diesel) 7 Seater	2013	750000	79328	Diesel	Trustmark Dealer	Manual	Second Owner	12.990000	2494.0	100.599998	200.000000	7.0	28
13	BMW X4 M Sport X xDrive20d	2019	5400000	7500	Diesel	Dealer	Automatic	First Owner	16.780001	1995.0	190.000000	400.000000	5.0	27
255	Maruti Baleno Alpha 1.3	2018	740000	38817	Diesel	Dealer	Manual	First Owner	27.389999	1248.0	74.000000	190.000000	5.0	27
306	Maruti Swift AMT ZXI	2018	600000	69779	Petrol	Dealer	Automatic	First Owner	22.000000	1197.0	81.800003	113.000000	5.0	27
363	Maruti Wagon R LXI	2013	225000	58343	Petrol	Trustmark Dealer	Manual	First Owner	21.790001	998.0	67.050003	90.000000	5.0	27
455	Toyota Etios VX	2017	625000	25538	Petrol	Trustmark Dealer	Manual	First Owner	16.780001	1496.0	88.730003	132.000000	5.0	27
114	Hyundai Grand i10 1.2 CRDi Sportz	2017	450000	56290	Diesel	Dealer	Manual	First Owner	24.000000	1186.0	73.970001	190.240005	5.0	26

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Correlations

Missing values

Sample

Duplicate rows

Most frequently occurring